﻿-- ===============================================================================================
-- Basic View for Rights
-- ===============================================================================================

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[esf_sso].[VRight]'))
	DROP VIEW [esf_sso].[VRight]
GO

-- SELECT * FROM [esf_sso].[VRight]

CREATE VIEW [esf_sso].[VRight] AS
	SELECT * FROM esf_sso.VBasicReference WHERE BasicReferenceTypeID = 13
	
GO   